UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MfnJPnUJrgggoUFo5Chxt3wHmxwbCQc1161gUuK8JxU='
WHERE
key_id = '93fcf39f7e20a78438daadb84bf2411f53afac2e4063d2718da470a5f76a9ccf'
AND (
token = 'MfnJPnUJrgggoUFo5Chxt3wHmxwbCQc1161gUuK8JxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)