UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gdk0cHkuNGbbzLOGnqllzkXPGLwoPRS9f9WBBprYtOE='
WHERE
key_id = '178d51b2634c92e1861dcd2bfbffd572275c05bce6258de329a2ac99036f6ae1'
AND (
token = 'gdk0cHkuNGbbzLOGnqllzkXPGLwoPRS9f9WBBprYtOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)