UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C+pcT4AqqMq6EvqBQFFHHBAk/tppTGxjXXVZncZtR+w='
WHERE
key_id = '47131def4468f0a0f6631eccfe88b65b1d54e876ff385a8dff01972643fcd480'
AND (
token = 'C+pcT4AqqMq6EvqBQFFHHBAk/tppTGxjXXVZncZtR+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)