UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hG96nde20tZwrYyHerSHHWAqbd6WmOMfi6igAy+Li4o='
WHERE
key_id = 'eb9b303a16b054d38a07d7d0fb31542915030170af523f450091b8a4b0778be4'
AND (
token = 'hG96nde20tZwrYyHerSHHWAqbd6WmOMfi6igAy+Li4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)