UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lN4TqvJprj3C1sw1xa+ijAI6Gvaz5w6j/OOs6AcG1t0='
WHERE
key_id = '6abf2109728e96938e15d335b502711e44ab6d25cb9c43fdeb9c69d0765c3240'
AND (
token = 'lN4TqvJprj3C1sw1xa+ijAI6Gvaz5w6j/OOs6AcG1t0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)