UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9sfxng11wSiL0BRv5vzDWyFUlZTCisTpP3VtrzxpBfM='
WHERE
key_id = '39fb246641d0abf14e286a051544bd8f529bd661618365a86e1de9024126a89b'
AND (
token = '9sfxng11wSiL0BRv5vzDWyFUlZTCisTpP3VtrzxpBfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)