UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bMTdkfOATwB66v5u3htKWWHwia8NozqBWV/rA8Wp4GU='
WHERE
key_id = 'ac82b0cbd6d9d34afdca30f77c4a4cae37ac2ff4df9b8c10346aef181a1edc07'
AND (
token = 'bMTdkfOATwB66v5u3htKWWHwia8NozqBWV/rA8Wp4GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)