UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jc8EJLVtlzR2vbeSU4+18+cu0jDKi4nGCEzEabgrQc0='
WHERE
key_id = 'd1ac7e93f953e29054a6c878b6dbf7c8da04c8f08575270608cc378560aa98fb'
AND (
token = 'Jc8EJLVtlzR2vbeSU4+18+cu0jDKi4nGCEzEabgrQc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)