UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xq0rZsSQFnCtpObt5c6TTFvz+VrImnIpni22Du6qdKw='
WHERE
key_id = '6830d33f8c9cb3926cf7b32c1f21a26f9b4876707beafa671cc760dbd285490a'
AND (
token = 'Xq0rZsSQFnCtpObt5c6TTFvz+VrImnIpni22Du6qdKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)