UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4PEb35AZvIxbCEKrVvIDShrSAsKHMVZL3qglpmoY47M='
WHERE
key_id = '6cfd655ed3767058826bf26b335508af611178754c87ec3e559a35c104e70a7f'
AND (
token = '4PEb35AZvIxbCEKrVvIDShrSAsKHMVZL3qglpmoY47M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)