UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'inKAn6x2YCmB/OgUjUyF36FRwLtB5Z8W126N8q+vGiE='
WHERE
key_id = 'bb6b119b8a1067cb6855a9995992576a95a94c4d3cb8cac88919ded400b1998f'
AND (
token = 'inKAn6x2YCmB/OgUjUyF36FRwLtB5Z8W126N8q+vGiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)