UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7hkm4Nu/1AAPZtDeDODlMUaomSAO7iwvnmUl7vQtbk='
WHERE
key_id = '8aff28b6bb9e0de5875d9863fcbcf76f0244600ac2455c2879dc3e8b0906bed0'
AND (
token = 'K7hkm4Nu/1AAPZtDeDODlMUaomSAO7iwvnmUl7vQtbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)