UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nq7Q93Nv7Xu/rn9g+iSgp1VoNtaust5RRAYnhy+q2gw='
WHERE
key_id = '8cd31680da3e9f9c58c816e65bbe854933825355437cf4720170387e881f24c1'
AND (
token = 'nq7Q93Nv7Xu/rn9g+iSgp1VoNtaust5RRAYnhy+q2gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)