UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QyiPrkr0pW7VJPJUufPwbIt0zUv8LLy1lieICFoNdgE='
WHERE
key_id = 'a3e63c5f0d20950eaff7b4986c383e24d0d3165b15bf6d996e0077be5dda0271'
AND (
token = 'QyiPrkr0pW7VJPJUufPwbIt0zUv8LLy1lieICFoNdgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)