UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g/IS6oPKyA2mRsXPgD3m1xOPhDCPzMXJ7rEqwN7Qab0='
WHERE
key_id = '78fd179c87e33180abb860491d6f78afa817424a80e04f412aef2de15e53fb42'
AND (
token = 'g/IS6oPKyA2mRsXPgD3m1xOPhDCPzMXJ7rEqwN7Qab0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)