UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3CA4fACoVhF5x3Pl3DjVF0b0pjuMy3C50uRJiBt9lus='
WHERE
key_id = 'aabfb44ce7774220a3046efd296446b7fa405723d062837dcdd00b7cb3234d9e'
AND (
token = '3CA4fACoVhF5x3Pl3DjVF0b0pjuMy3C50uRJiBt9lus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)