UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vJ6qg1rKzWqar13TBjLfP99J1KF141s2CwYTmoEBO3s='
WHERE
key_id = '6e9cb5c712e145fcdcb5f4da5a8b0f1ad5b8574b4adeaf71b95a8bfae871582a'
AND (
token = 'vJ6qg1rKzWqar13TBjLfP99J1KF141s2CwYTmoEBO3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)