UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zj1BqX7iUlTe75TE05XBAaRxHjkbFNn11ooV+YN0eRM='
WHERE
key_id = '367a640bb301d3c5b98f016b20f78fefd2854386d6ed1bd1985659273a44e944'
AND (
token = 'zj1BqX7iUlTe75TE05XBAaRxHjkbFNn11ooV+YN0eRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)