UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PX14I1mfYVtqLc5C+bsIMbZb9Qs6UUXVK3gS7EVXWo8='
WHERE
key_id = '5a5e05ca646dc71547114d5fe736b496ffce64ce392a26ecad51532af0fe11ab'
AND (
token = 'PX14I1mfYVtqLc5C+bsIMbZb9Qs6UUXVK3gS7EVXWo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)