UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zj8KONwaNjIPYcX6lpYX+FXBkLkP7hhGiBfFJub4Z2o='
WHERE
key_id = 'd5477fcc3a52d555042e24592559656f505fb8bb2ffa11926f781f172962887e'
AND (
token = 'Zj8KONwaNjIPYcX6lpYX+FXBkLkP7hhGiBfFJub4Z2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)