UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dTT7GgjMvLXGJIxmX9L8zplJ+lXeUMiOt3u2h3KauSQ='
WHERE
key_id = '18b71a309971c5e0185f8ea0f9efeac6766638af1d12518fea507f35f68f6ccc'
AND (
token = 'dTT7GgjMvLXGJIxmX9L8zplJ+lXeUMiOt3u2h3KauSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)