UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aUUaMj6I3sMl5x7SgYOdoVfEZ+KM4mccOiFxbRHiSxM='
WHERE
key_id = '563ead6741deb8e77bf2770e1c5db506117de9e9c2dc32399b04d8d1ac8d28dd'
AND (
token = 'aUUaMj6I3sMl5x7SgYOdoVfEZ+KM4mccOiFxbRHiSxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)