UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O6VOoFVbHSjPUaTuFVK8xGRBZaPnCj2ihyITBmMXkE8='
WHERE
key_id = 'a156fb10faaea65e2b58b699e1377375d167f2451b3f467f13948206e3921718'
AND (
token = 'O6VOoFVbHSjPUaTuFVK8xGRBZaPnCj2ihyITBmMXkE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)