UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ImIxvXsWeO3UdcmQhtwa1N8WQZRdvN0X+otvkdCaw0='
WHERE
key_id = '78f67e78cf8688d3cdc3b670cd05b5e569c9f595b0a61a71c7f0ed6cb7df5615'
AND (
token = '4ImIxvXsWeO3UdcmQhtwa1N8WQZRdvN0X+otvkdCaw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)