UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQAqLj025WM/xFxpcQ8RZJDUEBFqja+Ali+su0DC+Ec='
WHERE
key_id = '7c31cfd5d2cd2a3aa2d6edec39b4aa0fbd4531f3cbc61e21bdcd2df19b36af4f'
AND (
token = 'nQAqLj025WM/xFxpcQ8RZJDUEBFqja+Ali+su0DC+Ec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)