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