UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7km/hpr4bmcWAZ62zBm9FVoVXWgo9ruHgPXujCboXwg='
WHERE
key_id = 'a46010612b05d482d6a0936899527be848c82351fb140a1c67c16927e2005b95'
AND (
token = '7km/hpr4bmcWAZ62zBm9FVoVXWgo9ruHgPXujCboXwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)