UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fhbiWkBBqYu5uz5MGcHje9qVAEQtVokAwPQx905mGZM='
WHERE
key_id = '509e98c8c1405bc3256118510efd77ec970f6d7ae1882759fde987b73ee3b54d'
AND (
token = 'fhbiWkBBqYu5uz5MGcHje9qVAEQtVokAwPQx905mGZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)