UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/YlOGjLOGnWjDGUBwISzo/CTsB0OiqJMHsip251G3M4='
WHERE
key_id = 'ec696a771281a8be2e167afffeff375fe6053115367a33345f7bdc8ec94b9276'
AND (
token = '/YlOGjLOGnWjDGUBwISzo/CTsB0OiqJMHsip251G3M4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)