UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0svzYvYiQD6PFsF08o2MTqcusVr2bLQLZhkvVcgm/g='
WHERE
key_id = '9f3fdb2a82c45eeb37aa9b40f400137c49e96f9f46c1810bbee90a07a52bccce'
AND (
token = '/0svzYvYiQD6PFsF08o2MTqcusVr2bLQLZhkvVcgm/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)